Title: SQL W3S (By-BKK) / 043 Operators
Tags: Obsidian_to_Anki

Q: What does the SQL arithmetic operator + do?
A: It adds two numbers

Q: What does the SQL arithmetic operator - do?
A: It subtracts one number from another

Q: What does the SQL arithmetic operator * do?
A: It multiplies two numbers

Q: What does the SQL arithmetic operator / do?
A: It divides one number by another

Q: What does the SQL arithmetic operator % do?
A: It finds the remainder after division (modulo)

Q: - adds two values in SQL
A: What is the function of the + operator in SQL?

Q: - multiplies two numbers in SQL
A: What does the * operator do in SQL arithmetic?

Q: True/False: The SQL operator / is used to multiply numbers
A: False

Q: Which SQL operator returns the remainder after dividing two numbers?
A: %

Q: What is the use of the & bitwise SQL operator?
A: It performs bitwise AND

Q: What is the use of the | bitwise SQL operator?
A: It performs bitwise OR

Q: What is the use of the ^ bitwise SQL operator?
A: It performs bitwise exclusive OR

Q: What does = do in SQL comparisons?
A: It checks if two values are equal

Q: What does > do in SQL comparisons?
A: It checks if the left value is greater than the right

Q: What does < do in SQL comparisons?
A: It checks if the left value is less than the right

Q: What does >= do in SQL comparisons?
A: It checks if a value is greater than or equal to another

Q: What does <= do in SQL comparisons?
A: It checks if a value is less than or equal to another

Q: What does <> do in SQL comparisons?
A: It checks if values are not equal

Q: True/False: <> checks for equal values in SQL
A: False

Q: What does the SQL operator += do?
A: It adds and assigns the result to a variable

Q: What does the SQL operator -= do?
A: It subtracts and assigns the result to a variable

Q: What does the SQL operator *= do?
A: It multiplies and assigns the result to a variable

Q: What does the SQL operator /= do?
A: It divides and assigns the result to a variable

Q: What does the SQL operator %= do?
A: It calculates modulo and assigns the result to a variable

Q: What does the SQL operator &= do?
A: It performs bitwise AND and assigns the result

Q: What does the SQL operator ^= do?
A: It performs bitwise exclusive OR and assigns the result

Q: What does the SQL operator |= do?
A: It performs bitwise OR and assigns the result

Q: What does the ALL logical operator do in SQL?
A: Returns TRUE if all subquery values meet the condition

Q: What does the AND logical operator do in SQL?
A: Returns TRUE if all conditions are TRUE

Q: What does the ANY logical operator do in SQL?
A: Returns TRUE if any subquery value meets the condition

Q: What does the BETWEEN logical operator do in SQL?
A: Returns TRUE if the operand is within a range

Q: What does the EXISTS logical operator do in SQL?
A: Returns TRUE if a subquery returns one or more records

Q: What does the IN logical operator do in SQL?
A: Returns TRUE if a value equals any value in a list

Q: What does the LIKE logical operator do in SQL?
A: Returns TRUE if the value matches a pattern

Q: What does the NOT logical operator do in SQL?
A: Shows records if the condition is NOT TRUE

Q: What does the OR logical operator do in SQL?
A: Returns TRUE if any condition is TRUE

Q: What does the SOME logical operator do in SQL?
A: Returns TRUE if any subquery value meets the condition

Q: True/False: The AND operator returns TRUE only if all conditions are TRUE
A: True

Q: The IN operator checks if a value matches any in a list
A: What is the function of IN in SQL?

Q: EXISTS checks if a subquery returns records
A: What does EXISTS return TRUE for in SQL?

Q: LIKE matches patterns in SQL
A: What does LIKE check for?